ANSWERS: 2
  • How do you do this anyway? Can you not use the same condition in column B that you used in column C - but once again, how did you do it in column C anyway
  • This is very simple, really. Let's say that you used a Formula to evaluate Column C colors: =C1 >= 10 {Green} =C1 >= 5 {Yellow} =C1 <= 0 {Red} (Would mean that all values > 0 and < 5 would be 'white' cells; so you can actually have four formats.) Just apply the same formula across other columns. The trick is to modify the format to look at Column C in an 'absolute' way, so modify those formulas to: =$C1 >= 10 {Green} =$C1 >= 5 {Yellow} =$C1 <= 0 {Red} Now just do a Copy / Paste Special / Format onto any other cells that should also look at the value in C (or whatever other column is the basis of the format).

Copyright 2023, Wired Ivy, LLC

Answerbag | Terms of Service | Privacy Policy