Conditional Formatting: Font color for entire column based on another column

Hello,

I want a cell to change color if another cell contains the words "first aid". The text comes down from a drop down list and could read "First Aid" or "sleepover/first aid".

If the cell has "first aid" in it, I want the other cell to change color. I can get it to work if using formula f13=first aid but it won't change color if the cell says sleepover/first aid?

Can anyone help?

Hello,

would like to seek advice from some of the experts here.

I want to do conditional formatting from column O6-O21.

If percentage is above 100%, cell will be green filled with black font

If percentage between 80-100%, cell will be yellow filled with black font

If percentage is below 80%, cell will be red filled with black font

anyone can help?

THANK YOU!

Configuration: Windows XP / Chrome 42.0.2311.90

Hi there,

I have two columns which if equal(unless blank), I wish to fill in with a colour. I have defined the range as the two columns(BX3:BY3) and specify the formula to be evaluated as

=AND(BX3 = BY3,BX3"")

All that happens is the first column only gets filled in.

I then wish to apply the formatting down the columns from row 3 to row 30, where effectively the formula becomes =AND(BX4=BY4,BX4 "") --> =AND(BX30=BY30,BX30 "")

I have spent some time on this looking on the web for guidance but to no avail. Can you help please?

Thanks in advance
Terry Taylor

hi,
i am trying to create an excel vba code for creating a conditional formatting where i want to insert colour on the basis of multiple rules. i am new to excel hence finding it difficult to build a code

i have three column
column N : claimed Amount
Column J : Claim status
Column Q : Age

i want to use following conditions
a) if claimed Amount > 500 and < 50000 and claim status DI2,DI3,DI4 and age = 3 months green colour. if age = 4 months then yellow colour and if age is more than 4 months then colour should be red
b) if claimed amount > 50000 and 500000 and claim status is DI2 or DI3 or DI$ and age = 1 year but les...

hi,
need a formula or conditional format:
if cell a1 has text, then apply the color RED to cells underneath say a2-a15.
then, once numbers are inserted in the cells a2, a3, a4, etc, those cells keep the numbers but turn the cells back to no fill or white.

Hi,

I wonder if someone would be able to help me with this. This is probably really simple, but I can't get it to work. I need excel to change a cell to red if the due date on that cell is before today's date (date on that cell will change based on the date that is input on another cell), but only if the cell next to it has been left blank.

So if cell G2 has had a comment written on it, then cell H2 should be clear, regardless of the due date. If G2 has been left blank then H2 should be red if today is past the date on the cell. Hope that makes sense.

I've used this formula to determine if cell is past due date =$H$2