I have following formatting requirements - not sure if I can use conditional formatting (don't think so) so might be a worksheet_change event?
If NET =< 10,000 and GROSS =<100,000 highlight AE only
If NET =< 100,000 and GROSS =<1,000,000 highlight AE & AW
If NET =< 1,000,000 and GROSS =<25,000,000 highlight AW & HC
If NET =< 5,000,000 and GROSS =<100,000,000 highlight AW & HC & SH
If NET =< 30,000,000 and GROSS >100,000,000 highlight AW & HC & SH & CT
If NET > 30,000,000 Exec only (doesn't matter about gross)
The idea being as the numbers in each column are entered the adjacent cells would highlight according to the criteria listed.
Its a little complicated for my level and was hoping someone would help
Reply With Quote