Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting and Formulas
Hi.
I am using Excel 2003 to do some conditional formatting, but there are only three conditions to manipulate and I need four. I think though that I can comine two things together in a formula in one of the conditions - so that it would do the same formatting if either of two conditions were satisified - using the or condition. However, I am not sure how the OR function works or whether you can get round the three conditions issue in conditional formatting by doing this. The two things that I want to combine in an or function a ERROR.TYPE(I30=7) (I30="") So basically if either the cell is blank or if it has an error value in it I want to apply the same formatting. Can anyone suggest how I might put these together, is it just as simple as: =or((error.type(I30=7)),(I30="")) Thanks for your anticipated help. Liz. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting and Formulas
Not sure about the condition you want to apply but in general you can use
something like =OR(I7="",I7=10) in conditional formatting to check for either a blank or value 10 in I7... "BoRed79" wrote: Hi. I am using Excel 2003 to do some conditional formatting, but there are only three conditions to manipulate and I need four. I think though that I can comine two things together in a formula in one of the conditions - so that it would do the same formatting if either of two conditions were satisified - using the or condition. However, I am not sure how the OR function works or whether you can get round the three conditions issue in conditional formatting by doing this. The two things that I want to combine in an or function a ERROR.TYPE(I30=7) (I30="") So basically if either the cell is blank or if it has an error value in it I want to apply the same formatting. Can anyone suggest how I might put these together, is it just as simple as: =or((error.type(I30=7)),(I30="")) Thanks for your anticipated help. Liz. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formulas for Conditional Formatting | Excel Discussion (Misc queries) | |||
Conditional Formatting vs Formulas | Excel Discussion (Misc queries) | |||
Conditional formatting formulas | Excel Discussion (Misc queries) | |||
Conditional Formatting - Formulas | Excel Discussion (Misc queries) | |||
Help Using Formulas in Conditional Formatting | Excel Discussion (Misc queries) |