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.
- Progress
= bg green -
= bg blue - 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.
=> 0 and <99> There is a need to progress.
No comments:
Post a Comment