Forum Discussion
Conditional formatting
I have a sheet that has 6 columns and lots of rows. I would like to format each cell in column D based on the content of column A. ie. A1 is blank the D1 is blank, if A2 is not blank the D2 yellow. T...
Hi Ben,
Highlight from D1 to D100 (for example) and then apply the following conditional formatting formula
=$A1<>""
See below