condition formating

Hello community. First time posting one of these so I hope it makes sense. I am trying to use conditional monitoring to highlight a percentage loss from the Minimum recorded thickness (shown in V5-V29) from the original thickness (shown in D5-D29. I want to highlight the following: Any...

When "ITEM LIST" is selected in the range in particular cell, the HYPERLINK should be visible on the side. *My Hyperlink click and Jump Sheet 2 "Table 2" (Table 1 location = Sheet 1) My TABLE NAME IS = "Table 1" Range name (B3:B8) = "ITEM_LIST" How to possible This Query ??? Kindly Share...

Hi Everyone! I am trying to create a spreadsheet to better track equipment as well as personnel at work. The basic idea is managers at different sites submit daily a check list at that info is added to a sheet similar to my sample...

I'd like numbers for format in 0.00T, 0.00B, 0.00M and 0.00K But um, I guess I've messed up pushing it to Kilo. This works [>999999999999]0.00,,,,"T";[>999999999]0.00,,,"B";0.00,,"M" This doesn't work for me... [>999999999999]0.00,,,,,"T";[>999999999]0.00,,,,"B"[>999999]0.00,,,"M";0.00,,"K"...

Good morning, I am building a training tracker for work. I figured out how to use the conditional formatting to highlight when training will be due based on expiration dates. What I would like to do it have it show a % next to a persons name based on their row of training. So if a CBT date goes...

Hi, I’m hoping someone can help…I’ve read through quite a lot of threads and see that what I’m struggling with seems like a common thing…but I still can’t figure it out….I think my mind is zonked as I’m not a regular Excel user. Quick outline: I'm struggling to add/keep conditional formatting...

Hello, I am trying to highlight the value "0" with conditional formating in consecutives cells (in the table) in the same row and in the same colunm like I done manualy in picture b3a. The first value in the table is in cell B3. I have this formula...

Hey there!! I have a problem with my worksheet. <tbody> A B C D E F A/A name ΠΕΡΙΟΧΗ ΤΚ REP FOCUS 41308 ALBERT NAME ATHENS 33051 109 1 21776 KONSTANT NAME ATHENS 35001 109 2 38235 TSAPROS NAME LAMIA 35002 109 3 40982 ANESTOS LAMIA 35004 109 4 35287 MATSOS NAME MIKONOS 35004 109 4...

Hello, conditional format at the moment: =D8>=ROUNDUP($A8,0)/4 I would like to make it percentage but to round to a whole percent down if contains .4 or lower, and round up if contains .5 or more. im guessing something along the lines of =if(D8>=ROUNDUP($A8,0)/100*25....

H Excellers, I have a formula based total in I3 In E3 I have a formula based total too. I need to conditional format the I3. Red if greater than or equal to 25% of E3, Amber 10% to 24% of E3, Green if 0% to 9%. I do not have the space to create a separate percentage column. Thank you in...

I'm attempting to do a conditional format based on a formula. Row of data, B2:AC2 I would like to take the Average then have the cells highlight based less the Average. Lastly, I want to ignore 0. Example: Average is 20 Anything less than 20 is highlighted and anything 0 is not highlighted...

Hi, I have a huge dataset and I need to apply conditional formatting in a very strange and complex way. The data is a mix of hard coded and calculated prices. I need a formula that will apply formatting only if the cell ends with an 5 in the second decimal place (20.55, 5.05, 42.95, etc.). I've...