Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Conditional Format Blanks
Hi, I have read the previous threads on this subject, however I can't
find a response to my need. I am trying to apply conditional formatting to cells using a macro. However my range of data changes daily. What I would like to do is apply the conditional formatting to blanks in column F, ONLY if the cell next to it in Column E is NOT Blank. That way I can select the column as part of the macro, and not have to worry about my Blank cells beyond my data range being conditionally formatted. All help appreciated Thanks |
#2
|
|||
|
|||
The CF formula would be
=AND(E2<"",F2="") in F2 -- HTH RP (remove nothere from the email address if mailing direct) wrote in message ps.com... Hi, I have read the previous threads on this subject, however I can't find a response to my need. I am trying to apply conditional formatting to cells using a macro. However my range of data changes daily. What I would like to do is apply the conditional formatting to blanks in column F, ONLY if the cell next to it in Column E is NOT Blank. That way I can select the column as part of the macro, and not have to worry about my Blank cells beyond my data range being conditionally formatted. All help appreciated Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keep conditional format when "show pages" from Pivot table | Excel Discussion (Misc queries) | |||
How do I do a conditional format for numbers | Excel Worksheet Functions | |||
Office2000: Conditional format behaves strangely | Excel Discussion (Misc queries) | |||
copy conditional format as ACTUAL format | Excel Discussion (Misc queries) | |||
Copying a conditional format | Excel Worksheet Functions |