I'm in need of a conditional format formula that would turn a cell gray based on two conditions. My intention is to highlight a range from D3 through GG40 to have the condition formatting applicable for. The conditional format formula would then do the following:
First-The formula would need to identify any cells that have "H" in it from "D1:GG1" and then for those columns only apply the second condition, which is to look at column "GZ3" to "GZ40" and identify only those cells that have "DO" in them. As an end result example: if "D1" had an "H" in it and there was a "DO" in cells "GZ5" and "GZ6", cells "D5" & "D6" would turn gray, etc.
I tried using a formula like this: =AND(D1:GG1="H",$GZ3:$GZ34="DO") but it didn't work.
Any suggestions would be greatly appreciated!