Log In
Register
Home
Conditional Formatting
lea cohen
Member
Members
Forum Posts: 237
Member Since:
March 10, 2016
March 10, 2016
Offline1
November 20, 2018 - 4:41 pm
In the attachment I set 2 rules for formatting-
All cells over 500 colors in yellow
And each cell has between 400 and 700 colors in blue.
The question is what happens with the cells that say 600, 700
They answer the 2 conditions and I want to set up
Let them see that these cells meet the two conditions.
The question of how to do this ??
Velouria
London or thereabouts
Moderator
Members
Trusted Members
Moderators
Trusted Members
Moderators
Forum Posts: 690
Member Since:
November 1, 2018
November 1, 2018
Online2
November 20, 2018 - 9:09 pm
You might set up a third condition for >500 and <=700 and colour it green for example?
SunnyKow
Puchong, Malaysia
VIP
Members
Trusted Members
Trusted Members
Forum Posts: 1432
Member Since:
June 25, 2016
June 25, 2016
Offline3
November 21, 2018 - 2:03 am
Hi lea
If you set up a 3rd condition (like what Velouria suggested) then you will need to take into account which condition takes precedent first.
The Yellow or the Green? You will need to rearrange them correctly.
Maybe you can format these cells with YELLOW background and dotted BLUE patterns (instead of GREEN)?
Sunny
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Velouria
Guest(s) 11
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 880
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 237
Jessica Stewart: 219
A.Maurizio: 213
Aye Mu: 201
Hans Hallebeek: 186
Newest Members:
Kate Dyka
Kwaje Alfred Mogga
thong nguyen
Appiagyei Kofi Frimpong
Hilary Burchfield
Richie Wright
Adel Kock
Barbara Murray
Doug Milne
Siobhan Stringer
Forum Stats:
Groups: 3
Forums: 24
Topics: 6546
Posts: 28658
Member Stats:
Guest Posters: 49
Members: 32832
Moderators: 2
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: Velouria, Riny van Eekelen
© Simple:Press —