Highlight cells based on conditions
Format Conditional Formatting... FormulaIs
=AND(C1<"",B1C1) and pick a nice background color
--
Gary''s Student - gsnu200850
"Vic" wrote:
I need to highlight cell B if it is greater than cell C of the same row,
providing that cell C is NOT blank. All cells formated as date.
Thank you.
|