0021.PNG
Hi there anybody here can help me.
i want to do that base on FORMULA and what is the formula i need to use ??
for example when i type "OK" in "B2" in "C2" will change the background color into "RED"
0021.PNG
Hi there anybody here can help me.
i want to do that base on FORMULA and what is the formula i need to use ??
for example when i type "OK" in "B2" in "C2" will change the background color into "RED"
Select the range C2:C5
Conditional Formatting
New Rule
Use a formula to determine...
3 rules rwquired, one for each colour
=(C3="OK")
format as red
=(C3="PENDING")
format as yellow
=(C3="NOT OK")
format as green
P.S. Decide if you're gonna spell OK as OK or OKAY, looks a bit tacky spelling it two different ways.
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks