logo elektroda
logo elektroda
X
logo elektroda
Advanced Search
logo elektroda

Excel - change the color of cells in column B when in the same row B >= A

Condor59 8004 8
ADVERTISEMENT
Treść została przetłumaczona polish » english Zobacz oryginalną wersję tematu
| New topic
  • #1 16097553
    Condor59
    Level 9  
    Excel - I have column A - (it's called plan) from 01 to 30; a different number is entered in each cell.
    In column B (execution of the plan) I enter in each cell the actual numbers of the execution of this plan.
    How to make a rule for the entire column B (not for one cell) if B>= A the fields were green, and if B
  • ADVERTISEMENT
  • #2 16097561
    mariuszp19
    Level 35  
    Use conditional formatting.
  • #3 16097585
    Condor59
    Level 9  
    mariuszp19 wrote:
    Use conditional formatting.

    I tried - with a single cell no problem - with the whole column nothing comes out.
    The numbers in column A are different.
  • ADVERTISEMENT
  • #4 16097602
    mariuszp19
    Level 35  
    How does it not come out like it does? Submit a file.

    Added after 11 [minutes]:

    How does it not come out like it does? Submit a file.

    Is it something like this?
    Attachments:
  • ADVERTISEMENT
  • #5 16097707
    Condor59
    Level 9  
    mariuszp19 wrote:
    How does it not come out like it does? Submit a file.
    Added after 11 [minutes]:
    How does it not come out like it does? Submit a file.

    Is it something like this?

    that's exactly what it is - but how did you do it? :crazyeyes:
  • Helpful post
    #6 16097728
    mariuszp19
    Level 35  
    Conditional formatting - I already wrote. Excel - change the color of cells in column B when in the same row B >= A
  • #7 16097760
    Condor59
    Level 9  
    then I already know - conditional formatting - but what next - should the entire column B be selected? how to enter formula correctly - or select option - new formula - format all cells based on their values ? how to enter the minimum and maximum formula correctly?
  • Helpful post
    #8 16099807
    Tomuś_P
    Level 11  
    100% conditional formatting will work here :)
  • ADVERTISEMENT
  • #9 16445507
    Condor59
    Level 9  
    The problem is that you need to create the rule correctly -
    check the boxes of all the cells to which the formula applies
    click"
    1-conditional formatting.
    2-manage rules
    3-new rule
    4-format only containing cells
    5-extinguish from the cell value menu - for example: when the fields are empty, they should be silver - select equal (symbol ="") ok and click edit formula.
    6-click format
    7-click fill -effects - the first color is white, the second color is silver - ok, ok and apply -
    remember to type the cell value correctly - in this case they should be =""
    we do the same when the digit is greater than we assume, e.g. green color, or when the digit is smaller than we assume, eg red color - good luck!
| New topic
Report a violation of the law

Topic summary

The discussion revolves around using conditional formatting in Excel to change the color of cells in column B based on the values in column A. The user seeks to highlight cells in column B green when their values are greater than or equal to the corresponding values in column A. Initial attempts to apply the formatting to the entire column were unsuccessful, prompting further inquiries about the correct application of the conditional formatting rules. Participants provided step-by-step instructions on how to set up the rules, including selecting the entire column, managing rules, and entering the appropriate formulas for different conditions (e.g., empty cells, greater than, or less than). The consensus is that conditional formatting is the correct solution for this task.
Summary generated by the language model.
ADVERTISEMENT