Forum Discussion
Conditional Formatting Help
I want the name to highlight if column B is greater than cell C1.
CatherineMadden Highlight the column of names and then select conditional formatting -> New Rule
Then select to use a custom formula and type in =$B1>$C$1 and set the formatting accordingly:
The key here is that the number 1 in B1 does NOT have a $ before it (the B can so $B1 is good) and the 1 in C1 MUST have the $ before it (the C doesn't have to but can so $C$1 works)
Thank you, worked like a charm!
