LinkBack URL
About LinkBacks
Hi everyone
i am looking for a way to fill a cells with a colour based on a figure in a diferent cell
for example if A1 = 1 F6 will turn red, if A1= 2 F6 and G6 will turn red and so on
regards
Mark
Hi everyone
i am looking for a way to fill a cells with a colour based on a figure in a diferent cell
for example if A1 = 1 F6 will turn red, if A1= 2 F6 and G6 will turn red and so on
regards
Mark
Welcome to conditional formatting!
http://www.youtube.com/watch?v=jTztUryXNx0
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
like this ?
go to conditional formatting--> determine a formula
formula in conditional formatting is
=Columns($f$6:F6)<=$A$1
select color click ok
in apply to part select or type F1:XFD1
apply ok
Last edited by hemesh; 02-28-2014 at 01:52 PM.
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST
More we learn about excel, more it shows us, how less we know about it.
for chemistry
https://www.youtube.com/c/chemistrybyshivaansh
Thanks that is just what i am looking for but still a little confused do i have to highlight a cell before going to conditional formatting and if so which cell
Originally Posted by hemesh
after applying the formula go to conditional formatting tab again and select manage rule there you will see applies to you can change the reference here OR
first you can highlight the cells then you can apply conditional formatting.
cells as per your query is F6 to XFD6 which is last column
select F6 then hold control and SHif together and then right arrow key to select From F6 to XFD6
Thanks for the rep
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks