Log In
Register
Home
Project Management Dashboard - Conditional Formatting Help
AYANNA HARRIS
Active Member
Members
Forum Posts: 3
Member Since:
July 1, 2023
July 1, 2023
Offline1
July 1, 2023 - 1:21 am
Hello,
I have been stumped on why my conditional formatting is not working to display the progress in tasks for the completed days. I downloaded the file and my formatting and sheet set up seems to be identical, yet the formatting won't work.
I am using Excel 2016 on PC.
I would appreciate any guidance, thank you.
See Answer
Mynda Treacy
Admin
Forum Posts: 4782
Member Since:
July 16, 2010
July 16, 2010
Offline2
July 1, 2023 - 3:40 pm
Hi Ayanna,
Welcome to our forum! If you go into the conditional formatting manager you can see that the yellow format is applied to one cell: K8. You need to select the cells you want to format before applying the rule.
I hope that points you in the right direction, but come back if you get stuck again and share the file showing where you're up to and what you've tried.
Mynda
Answers Post
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Riny van Eekelen
Guest(s) 8
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1944
SunnyKow: 1432
Anders Sehlstedt: 956
Purfleet: 415
Hans Hallebeek: 377
Frans Visser: 351
David_Ng: 318
lea cohen: 248
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
Tiago Braga
Rehan Baig
Fred HORVATH
Silke Schmidt
Stuart Barr
Amelia Nolte
David Wier
T P Collins
Gerry Khoo
Jessica
Forum Stats:
Groups: 3
Forums: 25
Topics: 7149
Posts: 31373
Member Stats:
Guest Posters: 50
Members: 34653
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —