Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Conditional Format
I want to format the background of cell to a10 red if a10 is currently empty
and the length of the string in a5 is 1. Can somone offer the correct syntax for the conditional format of a10 as everything I try fails. Thanks, Fred |
#2
|
|||
|
|||
You need a condition of Formula is and a formula of
=AND(A10="",LEN(A5)=1) -- HTH RP (remove nothere from the email address if mailing direct) "Fred" wrote in message ... I want to format the background of cell to a10 red if a10 is currently empty and the length of the string in a5 is 1. Can somone offer the correct syntax for the conditional format of a10 as everything I try fails. Thanks, Fred |
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 |