Hi guys,
I want to highlight b1 if a1 is not blank. how to format this one?
thanks
Hi guys,
I want to highlight b1 if a1 is not blank. how to format this one?
thanks
blessed are those who share whats theirs
Use this formula in the conditional formatting dialogue window, then set your colours
Be carefule though as the reference to B1 is not absolute so if you dragged cell B1 across to C1, it would be looking at B1 instead of A1, same as a normal formula would. If you want it absolute, the change A1 to $A$1Please Login or Register to view this content.
thank you...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks