Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Dependant Conditional Formatting | Excel Discussion (Misc queries) | |||
Copy conditional formatting across multiple rows? | Excel Discussion (Misc queries) | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
How do I use conditional formatting for multiple rows? | Excel Worksheet Functions |