Thread: How to compare two cells in a worksheet and show the result as red or green in a cell in another wor
View Single Post
 
Old 07-02-2020, 01:35 PM
Purfleet Purfleet is offline Windows 10 Office 2019
Expert
  
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default
Conditional formatting should work for you.


Conditional formatting can be a bit moody to get use to the quirks but seems to do what you want


See attached
Reply With Quote