Hi
I am trying to do a conditional formatting on a column that fills red if a number is entered that does not equal 0.10 or 0.25.
I have tried numerous different formulas, but none of them are working
The cell already has lookup formulas in it, i just want to be able to highlight if they are not 0.10 or 0.25
Last edited by rhayes23; 03-03-2024 at 07:57 PM.
Use:Formula:
Please Login or Register to view this content.
Change the column letter as required.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Would that be in the "use formula to determine which cells to format?
I have tried that but highlights those 2 numbers, I need to have it so it highlights the other numbers that are entered, so it doesn't equal 0.10 or 0.25
Then:Formula:Please Login or Register to view this content.
That's it!!
Thank you so much,
You're welcome.
You may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks