Conditional Formatting Columns

lascough

Board Regular
Joined
Oct 31, 2003
Messages
74
Cells in column A will read "yes" or "no".
If cell A5 reads "no", B5,C5,D5 & E5 need to turn red. This should repeat all the way down the page. How can I do this. I can get individual cells to work but can not apply it to whole columns (colums B to E should all have the same conditional format).
 

Some videos you may like

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

Dutchy

Well-known Member
Joined
Sep 18, 2004
Messages
560
Highlight columns B to E

then put in the following conditional format

Formula is

=$A1="no"

and set a red format

this will then work for all rows
 

lascough

Board Regular
Joined
Oct 31, 2003
Messages
74
Conditional Formatting

Thanks for your reply.

I have managed to work that out and have specified a range of cells ($A1:$A500) and it works. However, I just wondered why it will not work when selecting the whole column ($A:$A).

Thanks.
 

Watch MrExcel Video

Forum statistics

Threads
1,127,092
Messages
5,622,653
Members
415,916
Latest member
eugenia

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top