Change background colour using formula

[Johnnyb]

I am looking to change the background colour of a cell when a specifi
formula returns false. Any help on this would be greatly appreciated.

Regards,

Johnny

 

[papou]

Hi Johnnyb
See Format, Conditonnal formatting
Say for instance your Formula returning false is in A1 and you wish to apply
format to B1
In B1:
Format, Conditionnal formatting
Formula is =A1=FALSE
And then apply relevant desired format

HTH
Cordially
Pascal

 

[Norman Harker]

Hi Johnnyb!

Select the cell with the formula
Format > Conditional Formatting
Cell Value Is
Equal to
FALSE
Format button
Select your format
OK
OK

 

[Johnnyb]

Nice one papou,

Regards,

Johnnyb

*Hi Johnnyb
See Format, Conditonnal formatting
Say for instance your Formula returning false is in A1 and you wis
to apply
format to B1
In B1:
Format, Conditionnal formatting
Formula is =A1=FALSE
And then apply relevant desired format

HTH
Cordially
Pascal

"Johnnyb >" <<[email protected]> a écrit dans l
message
de news:[email protected]...