Change color of cell and text

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

Is there a formula that can be used to change the color of
a cell and the text in the cell if a certain condition is
met.

For example in cell B3 "pass" or "fail" is the value base
on a condition in another cell. If B3 = "pass" then the
color of text and cell background can be as is - black
text on white background. If B3 = "fail" I need to make
it white text with red background. Does anyone know if
this can be done?

Thanks
 
You can certainly use Conditional Formatting to accomplish this. Format,
Conditional Formatting.

MRO
 
Hi Jeff,

Yes this can be done quite easily using Conditional
Formatting. Go to the cell reqiured .....B3....then from
the format menu goto conditional formating, in the first
box select 'cell value is' in the second box
select 'equal to' and then in the 3rd box type FAIL, then
click the format button and select the format you wish to
use, then click add>> add the second condition for PASS,
and select the format for that too.

Note using this option the entry must be the same as the
entry in the cell....ie 'pass' is not the same as 'PASS'
or 'Pass'
 
Back
Top