Sunday, 15 May 2011

google spreadsheet - GS>Conditional Formatting>Custom Formula> BG Color if number <, > or = -


I am creating a google spreadsheet and stuck in one point ....

This related For conditional formatting.

Actually, I want to create conditional formatting in custom formula, which will give BG color in the row based on the job status in the cell.

  1. Progress = bg green
  2. = bg blue
  3. for review = Bg Gray

I have 2 & amp; 3 using the following formula:

Done:

  conditional formatting> Custom Formula & gt; `= Indirect (" F "and row ()) = 100` Range> `C2: C1006, D2: E13, F2: F1006, G14: G16, D17: E1006`  

is for review by = 99

I hope the questions are clear, thanks.

me => 0 and <99>

There is a need to progress.

The answer will be: = $ F: $ F> 0 Category & gt; C2: F1006


No comments:

Post a Comment