I cant figure out the formula to colour the text in B1 if A1="sold"
This was my best guess:
Conditional formatting--> Formula is--> =if(A1="sold")
Anyone have a better idea?
I cant figure out the formula to colour the text in B1 if A1="sold"
This was my best guess:
Conditional formatting--> Formula is--> =if(A1="sold")
Anyone have a better idea?
Hi dbwoods11,
You are almost there... use remove "if" from the formula and try again.
Regards,
DILIPandey
<click on below * if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), [email protected]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks