Fill color with if function

[maz]

Hi.
I want to fill a cell with some color based on the value in other cell.
if a2>4 then a1 is blue.
Can anyone help me?
thanks

 

[Mike H]

Hi,

Use conditional formatting.
Select A1 then
Format|Conditional Formatting
Formula is
Enter the formula =A2>4
Pick you colour
OK

Mike

 

[Pete_UK]

You use conditional formatting to do this. Select A1, then click on
Format | Conditional Formatting and in the dialogue box select Formula
Is rather than Cell Value Is. Enter this formula:

=A2>4

Then click the Format button, then the Patterns tab (for background
colours) and choose your colour. OK your way out.

Hope this helps.

Pete

 

[L N]

I have a similar situation only I have 4 columns that I need all to be greater then 3 and then fill color to be used in my rank column. Is this possible?

 

[Spiky]

I have a similar situation only I have 4 columns that I need all to be greater then 3 and then fill color to be used in my rank column. Is this possible?

Use this formula in conditional formating for your rank column (adjust
to suit your references), then copy formats down the column.
=AND(B3>3,C3>3,D3>3,E3>3)