I am trying to highlite W3 when W3= (the letter H) and AA3 is blank. AA3 has the following formula:Please Login or Register to view this content.
I am trying to highlite W3 when W3= (the letter H) and AA3 is blank. AA3 has the following formula:Please Login or Register to view this content.
With W3 selected, click on Condtional Formatting | New Rule | Use a formula... , then put this formula in the dialogue box which pops up:
=AND(LEFT(W3)="H",AA3="")
Click on the Format button | Fill tab and choose your colour, then OK your way out.
Hope this helps.
Pete
I tried it but no luck. How about if 'W' = (letter H) and 'AB' is blank then format 'AB' to red fill?
Going off of post #3, you can do this:
Highlight AB2:AB100 (or however far your data can go) > Conditional Formatting > New Rule > Use a formula
=AND(W2="H",AB2="")
Format: Fill red > OK > OK
If you can't get that to work, I recommend uploading a small representative sample of your data along with the desired results (which you can enter manually) based on that data.
To upload an Excel workbook, follow these steps:
1) Click on "Go Advanced"
2) Click on "Manage Attachments"
3) Click on "Choose File"
4) Choose your file and click on "Open"
5) Click on "Upload"
6) Click on "Close this window"
1) ...when ... AA3 is blank ....
2) ...MATCH(IFERROR(MATCH(V816,H:H,0),"..")
A space between quotes is not an empty cell
Last edited by protonLeah; 12-11-2019 at 06:59 PM.
Ben Van Johnson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks