If in cell 1A i have a number.
Is it possible using conditional formatting to do the following:
If 1A is blank then cells C2:X20 text will be red.
I have tried and failed.
If in cell 1A i have a number.
Is it possible using conditional formatting to do the following:
If 1A is blank then cells C2:X20 text will be red.
I have tried and failed.
Select cells C2:X20 then click on Conditional Formatting | New Rule | Use a formula... , then put this formula in the dialogue box which pops up:
=$A$1=""
Click on the Format button | Fill tab and choose your colour (red), then click OK twice to exit the dialogue box.
Hope this helps.
Pete
Spot on exactly what I wanted.
Thank you.
P.S. why is it when I try and do it myself it never works and when you guys give the formula it makes sense
You're welcome - thanks for the rep.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks