Changle Font Colour of a Row using Conditional Formatting

**Madball** · 10-22-2007, 05:58 AM

Hi,

I'm currently trying to use conditional formatting to change a colour of the font in a row.

For example if you put a certain word into cell A1 it will change the colour of the text to green in cells A1 to A5. Just wondering how this can be done?

**VBA Noob** · 10-22-2007, 06:04 AM

Select A1 to A5 then place this formula into CF

=$A1="Your Text"

format as required. Change Your Text to your criteria

VBA Noob

**corinereyes** · 10-22-2007, 06:05 AM

Hi Madball,

Go to conditional formatting, select formula is and put

=$A$1:$A$5 <> ""

In the format select, go to pattern tab and select color green.

**Madball** · 10-22-2007, 06:15 AM

:S Errm it works a little, but not 100%.

OK let me try and show you how I've tried it so far, see where I'm going wrong. First off in cell I 39 I want to be able to put in either Sick, Holiday or absent. If the cell has Sick in it, I want it to turn cells A39 to I39 green. Currently when I try the two ideas above they don't seem to work, one of them just turns the text green with or without the word SICK in there.

=$A$39:$I$39 <> "SICK"

this is what I've tried in the code.

**corinereyes** · 10-22-2007, 06:46 AM

Hi Madball,

In cell A39
conditional formatting =$A$39 = "sick"

In cell A40
conditional formatting =$B$39 = "sick" and so on.

should be entered one by one in each cell.

Maybe there's a better way to do this.