Change background colour using formula

  • Thread starter Thread starter Johnnyb
  • Start date Start date
J

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
 
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
 
Hi Johnnyb!

Select the cell with the formula
Format > Conditional Formatting
Cell Value Is
Equal to
FALSE
Format button
Select your format
OK
OK
 
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]...
Click to expand...
 
Back
Top