Conditional Formatting - IF Function?

**Jings** · 06-08-2009, 04:24 AM

I am trying to colour a whole row of data (in columns A through to AA) based on the numeric entry in column AB. The numeric entry is either 1, 2 or 3. I reckoned I needed to use the IF function, but as writing formula is not my strong point I am struggling to enter the correct data! The first row of data I wish to use is 3. I have tried the following but to no avail: =IF($AB3,1). =IF($AB3=1). =IF($AB3="1"). Please tell me what I should be using

**squiggler47** · 06-08-2009, 04:31 AM

setting the conditional formatting to :

formula is :

=($ab3=1)

highlight a3-Ab100 to set conditional format

(note adjust the 100 to the range of your data!)

see attached sheet

**JBeaucaire** · 06-08-2009, 04:33 AM

Highlight the data from A3:AA1000
Open the conditional formatting window

Condition1: Formula Is:
=$AB3=1
Format...pattern...select color

Add>>
Condition2: Formula Is:
=$AB3=2
Format...pattern...select color

Add>>
Condition3: Formula Is:
=$AB3=3
Format...pattern...select color

**Jings** · 06-08-2009, 08:36 AM

Many thanks to both of you for your help. I guess I tried to overcomplicate things!

**Gorrynel** · 06-08-2009, 12:53 PM

This is not working for me because the Cell with the value that determines the highlighting is derived from a formula and not just a number. Is there a way to make this work for me as well?