Conditional Format

[krishnanaik]

Hi. I have a prob

Mon Am Mon Pm Att
0:00 0:00 SICK
0:00 0:00 HOL AM
0:00 0:00 HOL
0:00 0:00 HOL PM
2:00 0:00 SICK
0:00 0:00 LOAN OUT


If I have the following and want all the cells that contain HOL i.e HOL, HOL AM, HOL PM. Is there a function that allows us to say if the cell contains "HOL" then shade it red?

As I have 6 options I need a way of reducing the c.format to 3 (max number of conitional fromats). Hence the need to have the function that allows us to say if the cell containing all "HOL" then shade it red?

 

[Andrew Poulsom]

It's eg:

=LEFT(C1,3)="HOL"

 

[krishnanaik]

Thanks for that but cant seem to get it working.

What does the 3 represent?

HOL
HOL AM
HOL PM
SICK
LOAN


=LEFT(C1,3)="HOL"

This should highlight (after selecting) all cells with HOL in it. Where does the 3 come in?

 

[Andrew Poulsom]

Select the entries in column C and choose Format|Conditional Formatting from the menu. Condition 1 Formula is:

=LEFT(C1,3)="HOL"

where C1 is the first (active) cell in the selected range, click Format, choose a format and click OK twice.

The 3 means the first 3 characters.

 

[krishnanaik]

Cheers. Thats gr8