Conditional Formatting "OR" function
Hi Everyone,
I am changing a spreadsheet that hopefully when either for example a or s is entered in a cell the cell will go red. I already have other conditions in the spreadsheet for other formats. Does anyone know if this is possible? If it is possible can you please explain a little more than usual as I've only being "formatting" properly for around 2 months. Any info greatly appreciated. Baz |
Hi
in the conditional format dialog choose 'formula' and enter =OR(A1="s",A1="a") if A1 is your selected cell -- Regards Frank Kabel Frankfurt, Germany "Baz Masterson" <Baz schrieb im Newsbeitrag ... Hi Everyone, I am changing a spreadsheet that hopefully when either for example a or s is entered in a cell the cell will go red. I already have other conditions in the spreadsheet for other formats. Does anyone know if this is possible? If it is possible can you please explain a little more than usual as I've only being "formatting" properly for around 2 months. Any info greatly appreciated. Baz |
thanx frank,
if it was a selection instead of individual cell for example: $C$12:$U$285 could I change the formula to match? Thanx again for your help Baz "Frank Kabel" wrote: Hi in the conditional format dialog choose 'formula' and enter =OR(A1="s",A1="a") if A1 is your selected cell -- Regards Frank Kabel Frankfurt, Germany "Baz Masterson" <Baz schrieb im Newsbeitrag ... Hi Everyone, I am changing a spreadsheet that hopefully when either for example a or s is entered in a cell the cell will go red. I already have other conditions in the spreadsheet for other formats. Does anyone know if this is possible? If it is possible can you please explain a little more than usual as I've only being "formatting" properly for around 2 months. Any info greatly appreciated. Baz |
Hi Frank,
No not working at all. Enter data and no area changes colour. Any other ideas? Or does it seem kinda impossible? Rgds Baz "Frank Kabel" wrote: Hi try =SUM(COUNTIF($C$12:$U$285,{"a","s"})) -- Regards Frank Kabel Frankfurt, Germany "Baz masterson" <Baz schrieb im Newsbeitrag ... thanx frank, if it was a selection instead of individual cell for example: $C$12:$U$285 could I change the formula to match? Thanx again for your help Baz "Frank Kabel" wrote: Hi in the conditional format dialog choose 'formula' and enter =OR(A1="s",A1="a") if A1 is your selected cell -- Regards Frank Kabel Frankfurt, Germany "Baz Masterson" <Baz schrieb im Newsbeitrag ... Hi Everyone, I am changing a spreadsheet that hopefully when either for example a or s is entered in a cell the cell will go red. I already have other conditions in the spreadsheet for other formats. Does anyone know if this is possible? If it is possible can you please explain a little more than usual as I've only being "formatting" properly for around 2 months. Any info greatly appreciated. Baz |
Hi frank,
I set the format's on a single cell and then copied to the remaining cells and all works fine. Thanx Baz "Baz Masterson" wrote: Hi Everyone, I am changing a spreadsheet that hopefully when either for example a or s is entered in a cell the cell will go red. I already have other conditions in the spreadsheet for other formats. Does anyone know if this is possible? If it is possible can you please explain a little more than usual as I've only being "formatting" properly for around 2 months. Any info greatly appreciated. Baz |
All times are GMT +1. The time now is 04:10 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com