Conditional Highlighting across Cells
Hi there - thanks for reading.
In the screenshot below it shows in Column H conditional Highlighting RED if the date is in the past and PEACHY if it's in the future (ie. is the invoice overdue or not).
In Column I the fill is GREEN if the value is above zero (ie. to show the invoice as paid).
However, if it's been paid, I no longer want the red date in Column H.
I'd like to be able to type somewhere (where?)..:
IF (I4>0) THEN H4 'Fill a lovely green'
Can it be done?
Excited to find out.
Thanks again,
David
Mac mini, macOS 10.15