If Formula Problem.

[imlovely57]

I am using If formula But having problem please help me.

A1 = Job

i want to change color in red if A1<> Job by using if formula.

Conditional formatting is not working as my desired.

regards: imlovely57@gmail.com

 

[srikandi2000]

It works for me.


Select use a formula to determine which cells to format.


Then write : =C3="Job"


Click Format and choose your desired formatting.


Regards

 

[Faseeh]

Hi imlovely57,


If you want cell to be filled Red for every thing excluding "Job" then it should be:

=(A1<>"Job")

...place in conditional formatting menu and format cell fill to Red.


Regards,