|
|
#2
08-22-2022, 07:39 PM
|
||||
|
||||
Select column G and Add a new Conditional Format rule.
Choose a formula and set the Format you want to see In the formula box put in a formula using the first cell that aligns with the top of your selection eg =$C2<1 which assumes the first row of your selection is row 2.
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Conditional Formatting | RocketRon | Excel Programming | 2 | 11-25-2019 08:36 AM |
 Conditional formatting
|
marif300 | Project | 9 | 09-23-2014 07:23 AM |
|
Conditional formatting that ignores other formatting rules
|
info_guy2 | Excel | 1 | 07-03-2014 10:07 AM |
| conditional formatting | otuatail | Excel | 1 | 06-06-2012 05:07 AM |
|
Conditional Formatting.
|
Laurie B. | Excel | 6 | 04-09-2012 05:01 PM |
Windows 10 
Office 2016
Threaded Mode