Conditional Formatting

Hi all,

I need help to format a row of data given the input of a specific letter in a specific cell.

For example, in Column W i have a decision to make: Yes, Maybe, No.

Depending on the letter I write in this cell, (Y for yes, M for maybe, and N for no), i would like the following to happen:

Y formats the row, column C to L, GREEN
M formats the row, column C to L, YELLOW
N formats the row , column C to L, YELLOW

The letter i'm writing in always in Column W for the corresponding action to be taken on that row.

I've tried using conditional formatting function, but I think this requires a VBA.


Thanks!!!!

Thanks Fotis, great help!

What about if the value of a cell is within a certain tolerance level of difference?

For example:

To colour format the cells in column a, and i want to check them against a row of numbers for the same product in column a on a different excel sheet, where the colours tell me whether the number i am checking lies within a defined tolerance range of difference.



Objective being, to find the outlier from the set of numbers on Sheet 1 against the numbers on Sheet 2 for the same product, but from a different source.

Attached file for you to see.


Thanks again,

haha, i was very confused, but i see what happened there!

I am Grekis and Morayman. I used an old computer to write that which logged me in with an old username which i don't really use anymore, grekis!!! (actually had forogtten about)

Oh my, sorry about that. Same account, grekis is old. Do you want me to repost the question as morayman?

sry again for the confusion!!

thats great, thanks. given me some foundations to build upon here.
Last question!! How do i apply this to an already existing amount of data?

i guess this kind of applies more the the first question i had, with the colour for Y,N,M.

How to i apply this condition to a block of data already? Or do i have to apply the condition one by one?

thats great, thanks. given me some foundations to build upon here.
Last question!! How do i apply this to an already existing amount of data?

i guess this kind of applies more the the first question i had, with the colour for Y,N,M.

How to i apply this condition to a block of data already? Or do i have to apply the condition one by one?

Ignore last post, i was doing your first instruction wrong. Its now working fine.

That's great, thanks Fotis for you kind help.

Will be my pleasure to Rep you!