Hi,
I'm using Google Sheets but think it works the same way as it does in Excel.
Regarding conditional formatting, are there any easier ways of writing custom formulas to highlight a cell that's based on multiple other cells that all have the same condition?
e.g. The range to highlight is A1:C1
Is there a better custom formula that the ones I've written for the following example scenarios...
SCENARO 1
IF - E1,F1,G1,H1,K1,L1,M1 are all true
custom formula: =and($E1=true,$F1=true,$G1=true,$H1=true,$K1=true,$L1-true,$M1=true)
SCENARO 2
IF D1,E1 & F1 are ALL false but EITHER G1, H1 or K1 are true
custom formula: =and($D1=false,$E1=false,$F1=false,or($G1=true,$H1=true,$K1=true))
SCENARO 3
EITHER B1 OR C1 is true AND any of E1,G1, K1 are true)
custom formula: =and(or($B1=true,$C1=true),or($E1=,$G1=true,$K1=true))
Please tell me there's a better, easier way of writing these formulas because I've got a scenario where I need each row of cells (within the ranges A1:C35,E1:Y35) to highlight if EITHER B or C is true (for that particular row) and ALL of the cells between E and Y are false - I don't want to have to list every single cell in the formula but I don't know if there's any other way to do it.
I tried =and(or($B1=true,$C1=true),$E1:$Y1=false) but all that does is highlight the E to Y cells that match those conditions, when I need it to ALSO highlight the A to C cells.
PLEASE HELP!
Sally
Bookmarks