|  | Setting Conditional Formatting in 2007 saved as 97-2003 | | |
| | | Ed from AZ |  |
|  Posted: Wed Jun 11, 2008 10:15 pm Post subject: Setting Conditional Formatting in 2007 saved as 97-2003 |  |
I am working in XL 2007, but my workbooks save as the lower version.
I have two columns of cells that I would like to apply a Conditional
Format to. I figured out the Rules Manager. But I'm not sure about
applying my conditions.
I have three possible values in column A; depending on the value, I
want to set the font color in cols A and B. Would it be better to set
three separate conditions across the cells? Or use some type of IF
formula in one condition?
Ed |
| |
| | | Bernard Liengme | |
| | Posted: Wed Jun 11, 2008 10:33 pm Post subject: Re: Setting Conditional Formatting in 2007 saved as 97-2003 | |
Use three separate conditions
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
LINK
remove caps from email
"Ed from AZ" <prof_ofwhat@yahoo.com> wrote in message
news:deaa3146-da13-43cf-8e5f-deb5715c20c8@s21g2000prm.googlegroups.com...
| Quote: | I am working in XL 2007, but my workbooks save as the lower version.
I have two columns of cells that I would like to apply a Conditional
Format to. I figured out the Rules Manager. But I'm not sure about
applying my conditions.
I have three possible values in column A; depending on the value, I
want to set the font color in cols A and B. Would it be better to set
three separate conditions across the cells? Or use some type of IF
formula in one condition?
Ed |
|
| |
|
|
