Evening happy campers,
Trying to set a conditional format based on 2 cells.
Cell - G3 contains the format
If Cell A3 is not blank, and Cell H3 is blank, colour the cell as red background
I can get only 1 part of it work but i cant combine them both
Any takers for some easy rep ?
Regards
Galvinpaddy
You would need to use formula
=AND(A3<>"",H3="")
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
use a formula
=AND( A3 <> "", H3 = "")
OR you could use
ISBLANK()
NOT(ISBLANK())
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Epic, thanks both. Rep added.
your welcome - thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks