I am using excel to make my work schedules. I have a formula written looking for the word off in a cell and when the word off appears in a cell it shows me a total of how many times in another cell. My question is this is there a way to write a formula that once the word off shows up twice or more in a row the font for the cell showing the total off count changes color from like red to black?
use conditional formatting
Ed
GetURWingz
Welcome to excelforum
Please read forum rules (rule 7) & post your thread in the correct forum
Excel Programming is for VBA macro questions
Excel Worksheet Functions is for formula questions
A thread with the rules is available at the top of each forum or see link below for rules
Please Read Forum Rules Before Posting
Wrap VBA code by selecting the code and clicking the # icon or Read This
How To Cross Post politely
Top Excel links for beginners to Experts
If you are pleased with a member's answer then use the Scales icon to rate it
If my reply has assistedor failed to assist you
I welcome your Feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks