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

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

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,560
Messages
5,625,507
Members
416,115
Latest member
Gonzo5711

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