Hello. I use Excel 2003. I know its out dated but its the version i have to use at work. I need to highlight a cell based on conditions of 3 other cells on the same row...
Condition 1
Cell B2 must not be blank
Condition 2
Cell K2 must be blank
Condition 3
Cell H2 must not contain the string "NRN"
Then, if all conditions pass, D2 should be highlighted in RED
I appreciate any help I can get on this.
Thanks
nycDave
Bookmarks