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. This would apply to the whole sheet. I did this once but can't remember how.
Thanks for your help
Ben
- Thank you very much. That worked like a charm.
Hi Ben,
Highlight from D1 to D100 (for example) and then apply the following conditional formatting formula
=$A1<>""
See below
