Hello,
How can I ( in code) conditionally format columns B thru H (to last row in
columns) to be "No Fill Color" if the cells directly on the left and right on
the same row are populated? Example: If A1 and C1 are populated, the B1 would
have "No Fill".
Thank You for Your Help,
Terri

Hi
- select B1:H20
- goto the conditional format dialog
- enter the following formula:
=(A1<"")*(C1<"")
- choose your format

--
Regards
Frank Kabel
Frankfurt, Germany

"Terri" schrieb im Newsbeitrag
...
Hello,
How can I ( in code) conditionally format columns B thru H (to last
row in
columns) to be "No Fill Color" if the cells directly on the left and
right on
the same row are populated? Example: If A1 and C1 are populated, the
B1 would
have "No Fill".
Thank You for Your Help,
Terri