I have a sheet on Excel that is being fed from an access database query and i have been having so much trouble trying to do conditional formatting on it. Basically i need for the "Hours" column H to highlight red if they are >.2 of the "TGT" column F. All the traditional formatting i try does not work.Any ideas?
I can include the excel file but rather not due to sensitive info which i have hidden.
excelhelp.png
Last edited by cascencio83; 03-03-2015 at 12:32 AM.
Show your conditional Formatting Formula window
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Is the data in the Hours numeric or is it numbers stored as text?
If posting code please use code tags, see here.
It is being stored as text.
Select the Hours column, goto conditional formatting, select Use formula to determine cells to be formatted, enter this formula,
Formula:
Please Login or Register to view this content.
and choose the format you want
I'll try it in a bit when I return to work and post the status thanks.
Would it be .. H2-.2>F2 ?
Actually, if both columns have numbers as text try this.
Formula:Please Login or Register to view this content.
OK will do I'll get back to you on the outcome thank you.
This formula worked as I was needing it to thank you again!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks