Just looking for some help, i'm new to this whole world.
I'm trying to create a spreadsheet that has 6 columns each with a value of 1-3. If the value is 3 then the end "Warning" cell should be the colour green, if the value were 2 or 1 then the end cell should show as amber.
I know some basic VBA but I keep finding help based on Conditional Formatting - which is normally great. However, I cant seem to get it to do the above without putting a conditional format on for each variable on each cell. If I only had one row it would be ok, but I have 65 -I think Id go crazy before finishing that.
If there was any way for me to be able to select the entire row using CF and change the end cell colour based on the variables in that row then that would be great.
I hope this makes sense, any help someone could give would be fantastic.
Thanks!
Aucun commentaire:
Enregistrer un commentaire