can "if" formula be used to change cell formatting?

  • Thread starter Thread starter snsyg
  • Start date Start date
S

snsyg

hello,

can cell formatting conditionally change based on what the cell value
is by using an "if" formula?

basically what i am after is:

if value in cell A1="x" then cell A1 font color is red, else cell A1
font color is black.

if an x is input, it turns red, if anything else is input, it is
black.

i do not want to do this with a macro since i want the cell formatting
to change immediately upon editing the cell value.

can this be done?

thanks for your time!

karen
 
In the Format menu, choose Conditional Formatting

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
thanks niek! i was expecting something more complicated by way of
formula...this was so easy
 
Back
Top